This page last changed on Jan 23, 2009 by exm3763.

HTML results include icons to edit row.  Once in edit mode, table columns become input text fields and the icon changes from a pencil to an X (to cancel the edit and return the row to it's original state).  For each row, send old primary key, new one (if it's being updated) and all columns in the row.
 
The servlet will perform the update and use the refresh mechanism we choose for the refresh story (could be javascript on the client-side). 
 
Exceptions/Test Cases: 

  • Locked rows?
  • Updating a row that has been deleted
  • Huge columns (varchar 255 or something, medium text)
  • Update a row that has been updated already (should there be a warning?) 

servlet parameters for keys needs a specific structure to support multiple rows by using arrays
a table with one key column would send the key values for the rows to be updated in an array called "keyColumn1". a table with more columns would add more "keyColumn2" arrays to the request for each collumn

The  request will have to send the query along as well so that result metadata can be retrieved to figure out which columns are implied by the key columns.

Document generated by Confluence on May 21, 2009 10:23